Demystifying Data

06 - Data Visualisation

Mick Cooney

2022-10-13

Purpose

Tell A Story

Total Exposure of MTPL Data by Region


Region Total Exposure
Centre 102712.90
Ile-de-France 30208.64
Provence-Alpes-Cotes-D’Azur 35790.32
Rhone-Alpes 45347.42
Other 144440.16

Total Exposure of MTPL Data by Region


Region Total Exposure
Centre 102,712.90
Ile-de-France 30,208.64
Provence-Alpes-Cotes-D’Azur 35,790.32
Rhone-Alpes 45,347.42
Other 144,440.16

Chart Types

Line plots


Scatter plots

Histograms


Error lines

French Motor Third-Party Liability

CASdatasets


http://cas.uqam.ca/


https://github.com/dutangc/CASdatasets

Policy

IDpol ClaimNb Exposure VehPower VehAge DrivAge BonusMalus VehBrand VehGas Area Density Region
1 1 0.10 5 0 55 50 B12 Regular D 1217 Rhone-Alpes
3 1 0.77 5 0 55 50 B12 Regular D 1217 Rhone-Alpes
5 1 0.75 6 2 52 50 B12 Diesel B 54 Picardie
10 1 0.09 7 0 46 50 B12 Diesel B 76 Aquitaine
11 1 0.84 7 0 46 50 B12 Diesel B 76 Aquitaine


Claims

IDpol ClaimAmount
1552 995.20
1010996 1128.12
4024277 1851.11
4007252 1204.00
4046424 1204.00

678,013 Policy Rows


26,639 Claim Rows

Visualisation and Exploration

Claim Rates

Geospatial Data

Visualise Comparisons

Compare Region by Fuel Type

Compare Region by Vehicle Brand

Text Data

Word Cloud

IRISHMEN AND IRISHWOMEN: In the name of God and of the dead generations from which she
receives her old tradition of nationhood, Ireland, through us, summons her children to
her flag and strikes for her freedom. Having organised and trained her manhood through
her secret revolutionary organisation, the Irish Republican Brotherhood, and through
her open military organisations, the Irish Volunteers and the Irish Citizen Army, having
patiently perfected her discipline, having resolutely waited for the right moment to
reveal itself, she now seizes that moment and supported by her exiled children in America
and by gallant allies in Europe, but relying in the first on her own strength, she strikes
in full confidence of victory. We declare the right of the people of Ireland to the
ownership of Ireland and to the unfettered control of Irish destinies, to be sovereign
and indefeasible. The long usurpation of that right by a foreign people and government
has not extinguished the right, nor can it ever be extinguished except by the destruction
of the Irish people. In every generation the Irish people have asserted their right to
national freedom and sovereignty; six times during the past three hundred years they have
asserted it in arms. Standing on that fundamental right and again asserting it in arms in
the face of the world, we hereby proclaim the Irish Republic as a Sovereign Independent
State, and we pledge our lives and the lives of our comrades in arms to the cause of
its freedom, of its welfare, and of its exaltation among the nations. The Irish Republic
is entitled to, and hereby claims, the allegiance of every Irishman and Irishwoman. The
Republic guarantees religious and civil liberty, equal rights and equal opportunities to
all its citizens, and declares its resolve to pursue the happiness and prosperity of the
whole nation and of all its parts, cherishing all the children of the nation equally, and
oblivious of the differences carefully fostered by an alien Government, which have divided
a minority from the majority in the past. Until our arms have brought the opportune moment
for the establishment of a permanent National Government, representative of the whole
people of Ireland and elected by the suffrages of all her men and women, the Provisional
Government, hereby constituted, will administer the civil and military affairs of the
Republic in trust for the people. We place the cause of the Irish Republic under the
protection of the Most High God, Whose blessing we invoke upon our arms, and we pray
that no one who serves that cause will dishonour it by cowardice, inhumanity, or rapine.
In this supreme hour the Irish nation must, by its valour and discipline, and by the
readiness of its children to sacrifice themselves for the common good, prove itself worthy
of the august destiny to which it is called.

Stop words


(the, and, but, …)

Pie Charts

Exposure by Region

Region Total Exposure
Alsace 1,209.12
Aquitaine 14,322.17
Auvergne 2,322.88
Basse-Normandie 6,657.90
Bourgogne 5,025.36
Bretagne 27,753.46
Centre 102,712.90
Champagne-Ardenne 1,205.83
Corse 1,765.94
Franche-Comte 564.01
Haute-Normandie 3,177.68
Ile-de-France 30,208.64
Languedoc-Roussillon 14,736.10
Limousin 2,395.99
Midi-Pyrenees 7,020.11
Nord-Pas-de-Calais 19,611.75
Pays-de-la-Loire 21,934.03
Picardie 3,574.41
Poitou-Charentes 11,163.41
Provence-Alpes-Cotes-D’Azur 35,790.32
Rhone-Alpes 45,347.42

Aggregate Under 10%

Aggregate Under 5%

Summary

Book Suggestions

Thank You



https://github.com/kaybenleroll/data_workshops